/*
 Navicat Premium Data Transfer

 Source Server         : awesome-mall
 Source Server Type    : MariaDB
 Source Server Version : 100604
 Source Host           : localhost:3306
 Source Schema         : malldb

 Target Server Type    : MariaDB
 Target Server Version : 100604
 File Encoding         : 65001

 Date: 17/08/2021 18:37:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
                             `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户序号',
                             `first_name` varchar(255) DEFAULT '' COMMENT '用户名字',
                             `last_name` varchar(255) DEFAULT '' COMMENT '用户姓氏',
                             `phone` varchar(255) NOT NULL DEFAULT '' COMMENT '手机号',
                             `age` tinyint(5) DEFAULT 0 COMMENT '年龄',
                             `sex` tinyint(5) DEFAULT 1 COMMENT '性别',
                             `avatar` varchar(255) DEFAULT '' COMMENT '头像',
                             `password` varchar(255) DEFAULT '' COMMENT '登录密码',
                             `create_time` datetime DEFAULT current_timestamp() COMMENT '创建时间',
                             `update_time` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT '更新时间',
                             PRIMARY KEY (`id`),
                             UNIQUE KEY `key_phone` (`phone`) USING BTREE COMMENT '唯一手机号'
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` VALUES (1, '郭', '德纲', '110', 50, 1, '', '123456', '2021-08-16 22:12:48', '2021-08-16 22:13:04');
INSERT INTO `user_info` VALUES (2, '岳', '云鹏', '777777', 0, 1, '', '', '2021-08-17 18:25:03', '2021-08-17 18:25:03');
INSERT INTO `user_info` VALUES (3, '李', '云鹏', '3333333', 0, 1, '', '', '2021-08-17 18:29:11', '2021-08-17 18:29:11');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
